Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 52924 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.7 MiB |
| Average record size in memory | 232.0 B |
Variable types
| Numeric | 12 |
|---|---|
| DateTime | 2 |
| Categorical | 12 |
| Unsupported | 2 |
year_number has constant value "2019" | Constant |
Product_SKU has a high cardinality: 1145 distinct values | High cardinality |
Product_Description has a high cardinality: 404 distinct values | High cardinality |
Transaction_ID is highly correlated with week_number and 1 other fields | High correlation |
week_number is highly correlated with Transaction_ID and 1 other fields | High correlation |
month_number is highly correlated with Transaction_ID and 1 other fields | High correlation |
Location is highly correlated with year_number | High correlation |
Product_Category is highly correlated with year_number and 1 other fields | High correlation |
year_number is highly correlated with Location and 8 other fields | High correlation |
Coupon_Code is highly correlated with year_number and 2 other fields | High correlation |
User_type is highly correlated with year_number | High correlation |
GST is highly correlated with Product_Category and 2 other fields | High correlation |
Coupon_Status is highly correlated with year_number | High correlation |
Discount_pct is highly correlated with year_number and 1 other fields | High correlation |
Gender is highly correlated with year_number | High correlation |
revenue_seg is highly correlated with year_number | High correlation |
revenue is highly skewed (γ1 = 70.05685108) | Skewed |
Transaction_Date_Month_x is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Transaction_Date_Month_y is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2022-01-08 16:01:19.945592 |
|---|---|
| Analysis finished | 2022-01-08 16:04:25.316616 |
| Duration | 3 minutes and 5.37 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
CustomerID
Real number (ℝ≥0)
| Distinct | 1468 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15346.70981 |
|---|---|
| Minimum | 12346 |
| Maximum | 18283 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 12346 |
|---|---|
| 5-th percentile | 12585 |
| Q1 | 13869 |
| median | 15311 |
| Q3 | 16996.25 |
| 95-th percentile | 17967 |
| Maximum | 18283 |
| Range | 5937 |
| Interquartile range (IQR) | 3127.25 |
Descriptive statistics
| Standard deviation | 1766.55602 |
|---|---|
| Coefficient of variation (CV) | 0.1151097559 |
| Kurtosis | -1.234304871 |
| Mean | 15346.70981 |
| Median Absolute Deviation (MAD) | 1569 |
| Skewness | -0.03263921818 |
| Sum | 812209270 |
| Variance | 3120720.173 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 12748 | 695 | 1.3% |
| 15311 | 587 | 1.1% |
| 14606 | 575 | 1.1% |
| 17841 | 572 | 1.1% |
| 14911 | 523 | 1.0% |
| 13089 | 366 | 0.7% |
| 15039 | 315 | 0.6% |
| 17850 | 297 | 0.6% |
| 14646 | 290 | 0.5% |
| 13081 | 261 | 0.5% |
| Other values (1458) | 48443 |
| Value | Count | Frequency (%) |
| 12346 | 2 | < 0.1% |
| 12347 | 60 | |
| 12348 | 23 | < 0.1% |
| 12350 | 17 | < 0.1% |
| 12356 | 36 |
| Value | Count | Frequency (%) |
| 18283 | 102 | |
| 18277 | 1 | < 0.1% |
| 18269 | 8 | < 0.1% |
| 18260 | 40 | 0.1% |
| 18259 | 7 | < 0.1% |
| Distinct | 25061 |
|---|---|
| Distinct (%) | 47.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32409.82567 |
|---|---|
| Minimum | 16679 |
| Maximum | 48497 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 16679 |
|---|---|
| 5-th percentile | 18487 |
| Q1 | 25384 |
| median | 32625.5 |
| Q3 | 39126.25 |
| 95-th percentile | 46553.7 |
| Maximum | 48497 |
| Range | 31818 |
| Interquartile range (IQR) | 13742.25 |
Descriptive statistics
| Standard deviation | 8648.668977 |
|---|---|
| Coefficient of variation (CV) | 0.2668533013 |
| Kurtosis | -1.025369056 |
| Mean | 32409.82567 |
| Median Absolute Deviation (MAD) | 6872 |
| Skewness | 0.005581522873 |
| Sum | 1715257614 |
| Variance | 74799475.07 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 32526 | 35 | 0.1% |
| 22958 | 30 | 0.1% |
| 40807 | 29 | 0.1% |
| 34094 | 28 | 0.1% |
| 38059 | 27 | 0.1% |
| 25854 | 26 | < 0.1% |
| 41853 | 26 | < 0.1% |
| 24820 | 24 | < 0.1% |
| 33555 | 23 | < 0.1% |
| 33228 | 23 | < 0.1% |
| Other values (25051) | 52653 |
| Value | Count | Frequency (%) |
| 16679 | 1 | < 0.1% |
| 16680 | 1 | < 0.1% |
| 16681 | 1 | < 0.1% |
| 16682 | 10 | |
| 16684 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 48497 | 1 | |
| 48496 | 1 | |
| 48495 | 1 | |
| 48494 | 1 | |
| 48493 | 1 |
Transaction_Date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2019-12-31 00:00:00 |
| Distinct | 1145 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| GGOENEBJ079499 | 3511 |
|---|---|
| GGOENEBQ078999 | 3328 |
| GGOENEBB078899 | 3230 |
| GGOENEBQ079099 | 1361 |
| GGOENEBQ084699 | 1089 |
| Other values (1140) |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 13.99981105 |
| Min length | 12 |
Characters and Unicode
| Total characters | 740926 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 90 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | GGOENEBJ079499 |
|---|---|
| 2nd row | GGOENEBJ079499 |
| 3rd row | GGOENEBQ078999 |
| 4th row | GGOENEBQ079099 |
| 5th row | GGOENEBJ079499 |
| Value | Count | Frequency (%) |
| GGOENEBJ079499 | 3511 | 6.6% |
| GGOENEBQ078999 | 3328 | 6.3% |
| GGOENEBB078899 | 3230 | 6.1% |
| GGOENEBQ079099 | 1361 | 2.6% |
| GGOENEBQ084699 | 1089 | 2.1% |
| GGOENEBQ079199 | 1065 | 2.0% |
| GGOENEBQ086799 | 844 | 1.6% |
| GGOEGFKQ020399 | 806 | 1.5% |
| GGOENEBQ086499 | 599 | 1.1% |
| GGOEGDHC018299 | 583 | 1.1% |
| Other values (1135) | 36508 |
| Value | Count | Frequency (%) |
| ggoenebj079499 | 3511 | 6.6% |
| ggoenebq078999 | 3328 | 6.3% |
| ggoenebb078899 | 3230 | 6.1% |
| ggoenebq079099 | 1361 | 2.6% |
| ggoenebq084699 | 1089 | 2.1% |
| ggoenebq079199 | 1065 | 2.0% |
| ggoenebq086799 | 844 | 1.6% |
| ggoegfkq020399 | 806 | 1.5% |
| ggoenebq086499 | 599 | 1.1% |
| ggoegdhc018299 | 583 | 1.1% |
| Other values (1135) | 36508 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 137525 | |
| 9 | 86049 | |
| E | 73488 | |
| 0 | 66396 | 9.0% |
| O | 57949 | 7.8% |
| 1 | 35309 | 4.8% |
| A | 32219 | 4.3% |
| B | 30198 | 4.1% |
| 7 | 25140 | 3.4% |
| 8 | 23920 | 3.2% |
| Other values (24) | 172733 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 423376 | |
| Decimal Number | 317550 |
Most frequent character per category
| Value | Count | Frequency (%) |
| G | 137525 | |
| E | 73488 | |
| O | 57949 | |
| A | 32219 | 7.6% |
| B | 30198 | 7.1% |
| N | 16666 | 3.9% |
| Q | 15875 | 3.7% |
| J | 11340 | 2.7% |
| H | 8050 | 1.9% |
| C | 7226 | 1.7% |
| Other values (14) | 32840 | 7.8% |
| Value | Count | Frequency (%) |
| 9 | 86049 | |
| 0 | 66396 | |
| 1 | 35309 | |
| 7 | 25140 | 7.9% |
| 8 | 23920 | 7.5% |
| 3 | 19698 | 6.2% |
| 4 | 17305 | 5.4% |
| 6 | 15065 | 4.7% |
| 2 | 14669 | 4.6% |
| 5 | 13999 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 423376 | |
| Common | 317550 |
Most frequent character per script
| Value | Count | Frequency (%) |
| G | 137525 | |
| E | 73488 | |
| O | 57949 | |
| A | 32219 | 7.6% |
| B | 30198 | 7.1% |
| N | 16666 | 3.9% |
| Q | 15875 | 3.7% |
| J | 11340 | 2.7% |
| H | 8050 | 1.9% |
| C | 7226 | 1.7% |
| Other values (14) | 32840 | 7.8% |
| Value | Count | Frequency (%) |
| 9 | 86049 | |
| 0 | 66396 | |
| 1 | 35309 | |
| 7 | 25140 | 7.9% |
| 8 | 23920 | 7.5% |
| 3 | 19698 | 6.2% |
| 4 | 17305 | 5.4% |
| 6 | 15065 | 4.7% |
| 2 | 14669 | 4.6% |
| 5 | 13999 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 740926 |
Most frequent character per block
| Value | Count | Frequency (%) |
| G | 137525 | |
| 9 | 86049 | |
| E | 73488 | |
| 0 | 66396 | 9.0% |
| O | 57949 | 7.8% |
| 1 | 35309 | 4.8% |
| A | 32219 | 4.3% |
| B | 30198 | 4.1% |
| 7 | 25140 | 3.4% |
| 8 | 23920 | 3.2% |
| Other values (24) | 172733 |
| Distinct | 404 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | 3511 |
|---|---|
| Nest Cam Outdoor Security Camera - USA | 3328 |
| Nest Cam Indoor Security Camera - USA | 3230 |
| Google Sunglasses | 1523 |
| Nest Protect Smoke + CO White Battery Alarm-USA | 1361 |
| Other values (399) |
Length
| Max length | 59 |
|---|---|
| Median length | 37 |
| Mean length | 34.16423551 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1808108 |
|---|---|
| Distinct characters | 74 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel |
|---|---|
| 2nd row | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel |
| 3rd row | Nest Cam Outdoor Security Camera - USA |
| 4th row | Nest Protect Smoke + CO White Battery Alarm-USA |
| 5th row | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel |
| Value | Count | Frequency (%) |
| Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | 3511 | 6.6% |
| Nest Cam Outdoor Security Camera - USA | 3328 | 6.3% |
| Nest Cam Indoor Security Camera - USA | 3230 | 6.1% |
| Google Sunglasses | 1523 | 2.9% |
| Nest Protect Smoke + CO White Battery Alarm-USA | 1361 | 2.6% |
| Nest Learning Thermostat 3rd Gen-USA - White | 1089 | 2.1% |
| Nest Protect Smoke + CO White Wired Alarm-USA | 1065 | 2.0% |
| Google 22 oz Water Bottle | 902 | 1.7% |
| Nest Thermostat E - USA | 844 | 1.6% |
| Google Laptop and Cell Phone Stickers | 806 | 1.5% |
| Other values (394) | 35265 |
| Value | Count | Frequency (%) |
| 21790 | 7.2% | |
| 17529 | 5.8% | |
| nest | 16528 | 5.5% |
| tee | 11533 | 3.8% |
| men's | 9080 | 3.0% |
| usa | 8742 | 2.9% |
| sleeve | 7964 | 2.6% |
| cam | 7448 | 2.5% |
| short | 7241 | 2.4% |
| security | 6697 | 2.2% |
| Other values (392) | 186249 |
Most occurring characters
| Value | Count | Frequency (%) |
| 248342 | 13.7% | |
| e | 228054 | 12.6% |
| o | 131832 | 7.3% |
| t | 107130 | 5.9% |
| a | 91639 | 5.1% |
| r | 90077 | 5.0% |
| l | 81603 | 4.5% |
| n | 67451 | 3.7% |
| S | 62355 | 3.4% |
| s | 58792 | 3.3% |
| Other values (64) | 640833 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1177477 | |
| Uppercase Letter | 318134 | 17.6% |
| Space Separator | 248342 | 13.7% |
| Dash Punctuation | 23080 | 1.3% |
| Decimal Number | 19806 | 1.1% |
| Other Punctuation | 18283 | 1.0% |
| Math Symbol | 2531 | 0.1% |
| Currency Symbol | 159 | < 0.1% |
| Open Punctuation | 148 | < 0.1% |
| Close Punctuation | 148 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| S | 62355 | |
| G | 30771 | |
| C | 27982 | |
| T | 24893 | 7.8% |
| A | 23994 | 7.5% |
| N | 19477 | 6.1% |
| B | 18430 | 5.8% |
| U | 16517 | 5.2% |
| W | 14268 | 4.5% |
| M | 12393 | 3.9% |
| Other values (16) | 67054 |
| Value | Count | Frequency (%) |
| e | 228054 | |
| o | 131832 | |
| t | 107130 | |
| a | 91639 | 7.8% |
| r | 90077 | 7.7% |
| l | 81603 | 6.9% |
| n | 67451 | 5.7% |
| s | 58792 | 5.0% |
| i | 48194 | 4.1% |
| g | 41246 | 3.5% |
| Other values (16) | 231459 |
| Value | Count | Frequency (%) |
| 3 | 5401 | |
| 0 | 4048 | |
| 1 | 3489 | |
| 2 | 3443 | |
| 4 | 1260 | 6.4% |
| 5 | 926 | 4.7% |
| 7 | 547 | 2.8% |
| 6 | 408 | 2.1% |
| 8 | 258 | 1.3% |
| 9 | 26 | 0.1% |
| Value | Count | Frequency (%) |
| ' | 13469 | |
| / | 1932 | 10.6% |
| % | 1726 | 9.4% |
| & | 853 | 4.7% |
| . | 159 | 0.9% |
| ; | 144 | 0.8% |
| Value | Count | Frequency (%) |
| 248342 |
| Value | Count | Frequency (%) |
| - | 23080 |
| Value | Count | Frequency (%) |
| + | 2531 |
| Value | Count | Frequency (%) |
| ( | 148 |
| Value | Count | Frequency (%) |
| ) | 148 |
| Value | Count | Frequency (%) |
| $ | 159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1495611 | |
| Common | 312497 | 17.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 228054 | |
| o | 131832 | 8.8% |
| t | 107130 | 7.2% |
| a | 91639 | 6.1% |
| r | 90077 | 6.0% |
| l | 81603 | 5.5% |
| n | 67451 | 4.5% |
| S | 62355 | 4.2% |
| s | 58792 | 3.9% |
| i | 48194 | 3.2% |
| Other values (42) | 528484 |
| Value | Count | Frequency (%) |
| 248342 | ||
| - | 23080 | 7.4% |
| ' | 13469 | 4.3% |
| 3 | 5401 | 1.7% |
| 0 | 4048 | 1.3% |
| 1 | 3489 | 1.1% |
| 2 | 3443 | 1.1% |
| + | 2531 | 0.8% |
| / | 1932 | 0.6% |
| % | 1726 | 0.6% |
| Other values (12) | 5036 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1808108 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 248342 | 13.7% | |
| e | 228054 | 12.6% |
| o | 131832 | 7.3% |
| t | 107130 | 5.9% |
| a | 91639 | 5.1% |
| r | 90077 | 5.0% |
| l | 81603 | 4.5% |
| n | 67451 | 3.7% |
| S | 62355 | 3.4% |
| s | 58792 | 3.3% |
| Other values (64) | 640833 |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Apparel | |
|---|---|
| Nest-USA | |
| Office | |
| Drinkware | |
| Lifestyle | |
| Other values (15) |
Length
| Max length | 20 |
|---|---|
| Median length | 7 |
| Mean length | 7.374650442 |
| Min length | 3 |
Characters and Unicode
| Total characters | 390296 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nest-USA |
|---|---|
| 2nd row | Nest-USA |
| 3rd row | Nest-USA |
| 4th row | Nest-USA |
| 5th row | Nest-USA |
| Value | Count | Frequency (%) |
| Apparel | 18126 | |
| Nest-USA | 14013 | |
| Office | 6513 | 12.3% |
| Drinkware | 3483 | 6.6% |
| Lifestyle | 3092 | 5.8% |
| Nest | 2198 | 4.2% |
| Bags | 1882 | 3.6% |
| Headgear | 771 | 1.5% |
| Notebooks & Journals | 749 | 1.4% |
| Waze | 554 | 1.0% |
| Other values (10) | 1543 | 2.9% |
| Value | Count | Frequency (%) |
| apparel | 18126 | |
| nest-usa | 14013 | |
| office | 6513 | 11.9% |
| drinkware | 3483 | 6.4% |
| lifestyle | 3092 | 5.7% |
| nest | 2198 | 4.0% |
| bags | 1928 | 3.5% |
| headgear | 771 | 1.4% |
| 749 | 1.4% | |
| journals | 749 | 1.4% |
| Other values (13) | 3005 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 54810 | |
| p | 36341 | 9.3% |
| A | 32416 | 8.3% |
| a | 27792 | 7.1% |
| r | 27216 | 7.0% |
| s | 24508 | 6.3% |
| l | 22340 | 5.7% |
| t | 21064 | 5.4% |
| N | 17277 | 4.4% |
| f | 16277 | 4.2% |
| Other values (28) | 110255 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 277280 | |
| Uppercase Letter | 96234 | 24.7% |
| Dash Punctuation | 14330 | 3.7% |
| Space Separator | 1703 | 0.4% |
| Other Punctuation | 749 | 0.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 54810 | |
| p | 36341 | |
| a | 27792 | |
| r | 27216 | |
| s | 24508 | |
| l | 22340 | |
| t | 21064 | 7.6% |
| f | 16277 | 5.9% |
| i | 13524 | 4.9% |
| c | 7159 | 2.6% |
| Other values (10) | 26249 |
| Value | Count | Frequency (%) |
| A | 32416 | |
| N | 17277 | |
| U | 14013 | |
| S | 14013 | |
| O | 6513 | 6.8% |
| D | 3483 | 3.6% |
| L | 3092 | 3.2% |
| B | 2285 | 2.4% |
| H | 893 | 0.9% |
| J | 749 | 0.8% |
| Other values (5) | 1500 | 1.6% |
| Value | Count | Frequency (%) |
| - | 14330 |
| Value | Count | Frequency (%) |
| 1703 |
| Value | Count | Frequency (%) |
| & | 749 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 373514 | |
| Common | 16782 | 4.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 54810 | |
| p | 36341 | 9.7% |
| A | 32416 | 8.7% |
| a | 27792 | 7.4% |
| r | 27216 | 7.3% |
| s | 24508 | 6.6% |
| l | 22340 | 6.0% |
| t | 21064 | 5.6% |
| N | 17277 | 4.6% |
| f | 16277 | 4.4% |
| Other values (25) | 93473 |
| Value | Count | Frequency (%) |
| - | 14330 | |
| 1703 | 10.1% | |
| & | 749 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 390296 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 54810 | |
| p | 36341 | 9.3% |
| A | 32416 | 8.3% |
| a | 27792 | 7.1% |
| r | 27216 | 7.0% |
| s | 24508 | 6.3% |
| l | 22340 | 5.7% |
| t | 21064 | 5.4% |
| N | 17277 | 4.4% |
| f | 16277 | 4.2% |
| Other values (28) | 110255 |
Quantity
Real number (ℝ≥0)
| Distinct | 151 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.497638123 |
|---|---|
| Minimum | 1 |
| Maximum | 900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 16 |
| Maximum | 900 |
| Range | 899 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 20.10471082 |
|---|---|
| Coefficient of variation (CV) | 4.470059679 |
| Kurtosis | 525.4524846 |
| Mean | 4.497638123 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.03480155 |
| Sum | 238033 |
| Variance | 404.1993973 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 35336 | |
| 2 | 7016 | 13.3% |
| 3 | 2288 | 4.3% |
| 5 | 1734 | 3.3% |
| 4 | 1237 | 2.3% |
| 10 | 1035 | 2.0% |
| 20 | 531 | 1.0% |
| 6 | 435 | 0.8% |
| 15 | 389 | 0.7% |
| 25 | 287 | 0.5% |
| Other values (141) | 2636 | 5.0% |
| Value | Count | Frequency (%) |
| 1 | 35336 | |
| 2 | 7016 | 13.3% |
| 3 | 2288 | 4.3% |
| 4 | 1237 | 2.3% |
| 5 | 1734 | 3.3% |
| Value | Count | Frequency (%) |
| 900 | 1 | < 0.1% |
| 825 | 2 | < 0.1% |
| 791 | 1 | < 0.1% |
| 750 | 1 | < 0.1% |
| 600 | 5 |
Avg_Price
Real number (ℝ≥0)
| Distinct | 546 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.23764644 |
|---|---|
| Minimum | 0.39 |
| Maximum | 355.74 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 0.39 |
|---|---|
| 5-th percentile | 1.99 |
| Q1 | 5.7 |
| median | 16.99 |
| Q3 | 102.13 |
| 95-th percentile | 151.88 |
| Maximum | 355.74 |
| Range | 355.35 |
| Interquartile range (IQR) | 96.43 |
Descriptive statistics
| Standard deviation | 64.0068816 |
|---|---|
| Coefficient of variation (CV) | 1.225301788 |
| Kurtosis | 3.342401681 |
| Mean | 52.23764644 |
| Median Absolute Deviation (MAD) | 14.19 |
| Skewness | 1.632579807 |
| Sum | 2764625.2 |
| Variance | 4096.880892 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 119 | 5127 | 9.7% |
| 149 | 3824 | 7.2% |
| 79 | 1937 | 3.7% |
| 13.59 | 1530 | 2.9% |
| 2.39 | 1284 | 2.4% |
| 2.99 | 1226 | 2.3% |
| 16.99 | 1036 | 2.0% |
| 15.19 | 984 | 1.9% |
| 1.99 | 956 | 1.8% |
| 3.99 | 949 | 1.8% |
| Other values (536) | 34071 |
| Value | Count | Frequency (%) |
| 0.39 | 1 | < 0.1% |
| 0.4 | 45 | |
| 0.41 | 15 | < 0.1% |
| 0.5 | 33 | |
| 0.51 | 27 |
| Value | Count | Frequency (%) |
| 355.74 | 169 | |
| 349 | 330 | |
| 279 | 147 | |
| 274.19 | 3 | < 0.1% |
| 269 | 1 | < 0.1% |
Delivery_Charges
Real number (ℝ≥0)
| Distinct | 267 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.51763038 |
|---|---|
| Minimum | 0 |
| Maximum | 521.36 |
| Zeros | 162 |
| Zeros (%) | 0.3% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 6 |
| median | 6 |
| Q3 | 6.5 |
| 95-th percentile | 26.43 |
| Maximum | 521.36 |
| Range | 521.36 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 19.47561323 |
|---|---|
| Coefficient of variation (CV) | 1.85171113 |
| Kurtosis | 204.6376899 |
| Mean | 10.51763038 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.95973935 |
| Sum | 556635.07 |
| Variance | 379.2995108 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 6 | 26801 | |
| 6.5 | 15819 | |
| 12.99 | 2532 | 4.8% |
| 19.99 | 1042 | 2.0% |
| 12.48 | 798 | 1.5% |
| 12.91 | 454 | 0.9% |
| 8.7 | 325 | 0.6% |
| 0 | 162 | 0.3% |
| 18.47 | 139 | 0.3% |
| 13.38 | 111 | 0.2% |
| Other values (257) | 4741 | 9.0% |
| Value | Count | Frequency (%) |
| 0 | 162 | 0.3% |
| 6 | 26801 | |
| 6.46 | 14 | < 0.1% |
| 6.48 | 29 | 0.1% |
| 6.5 | 15819 |
| Value | Count | Frequency (%) |
| 521.36 | 1 | < 0.1% |
| 504 | 2 | < 0.1% |
| 492.84 | 10 | |
| 422.24 | 4 | < 0.1% |
| 354 | 3 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Clicked | |
|---|---|
| Used | |
| Not Used |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.138047011 |
| Min length | 4 |
Characters and Unicode
| Total characters | 324850 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Used |
|---|---|
| 2nd row | Used |
| 3rd row | Not Used |
| 4th row | Clicked |
| 5th row | Clicked |
| Value | Count | Frequency (%) |
| Clicked | 26926 | |
| Used | 17904 | |
| Not Used | 8094 | 15.3% |
| Value | Count | Frequency (%) |
| clicked | 26926 | |
| used | 25998 | |
| not | 8094 | 13.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 52924 | |
| d | 52924 | |
| C | 26926 | |
| l | 26926 | |
| i | 26926 | |
| c | 26926 | |
| k | 26926 | |
| U | 25998 | |
| s | 25998 | |
| N | 8094 | 2.5% |
| Other values (3) | 24282 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 255738 | |
| Uppercase Letter | 61018 | 18.8% |
| Space Separator | 8094 | 2.5% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 52924 | |
| d | 52924 | |
| l | 26926 | |
| i | 26926 | |
| c | 26926 | |
| k | 26926 | |
| s | 25998 | |
| o | 8094 | 3.2% |
| t | 8094 | 3.2% |
| Value | Count | Frequency (%) |
| C | 26926 | |
| U | 25998 | |
| N | 8094 | 13.3% |
| Value | Count | Frequency (%) |
| 8094 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 316756 | |
| Common | 8094 | 2.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 52924 | |
| d | 52924 | |
| C | 26926 | |
| l | 26926 | |
| i | 26926 | |
| c | 26926 | |
| k | 26926 | |
| U | 25998 | |
| s | 25998 | |
| N | 8094 | 2.6% |
| Other values (2) | 16188 | 5.1% |
| Value | Count | Frequency (%) |
| 8094 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 324850 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 52924 | |
| d | 52924 | |
| C | 26926 | |
| l | 26926 | |
| i | 26926 | |
| c | 26926 | |
| k | 26926 | |
| U | 25998 | |
| s | 25998 | |
| N | 8094 | 2.5% |
| Other values (3) | 24282 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| F | |
|---|---|
| M |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 52924 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | M |
| 4th row | M |
| 5th row | M |
| Value | Count | Frequency (%) |
| F | 33007 | |
| M | 19917 |
| Value | Count | Frequency (%) |
| f | 33007 | |
| m | 19917 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 33007 | |
| M | 19917 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 52924 |
Most frequent character per category
| Value | Count | Frequency (%) |
| F | 33007 | |
| M | 19917 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 52924 |
Most frequent character per script
| Value | Count | Frequency (%) |
| F | 33007 | |
| M | 19917 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 52924 |
Most frequent character per block
| Value | Count | Frequency (%) |
| F | 33007 | |
| M | 19917 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Chicago | |
|---|---|
| California | |
| New York | |
| New Jersey | |
| Washington DC |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 8.690764115 |
| Min length | 7 |
Characters and Unicode
| Total characters | 459950 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Chicago |
|---|---|
| 2nd row | Chicago |
| 3rd row | Chicago |
| 4th row | Chicago |
| 5th row | Chicago |
| Value | Count | Frequency (%) |
| Chicago | 18380 | |
| California | 16136 | |
| New York | 11173 | |
| New Jersey | 4503 | 8.5% |
| Washington DC | 2732 | 5.2% |
| Value | Count | Frequency (%) |
| chicago | 18380 | |
| california | 16136 | |
| new | 15676 | |
| york | 11173 | |
| jersey | 4503 | 6.3% |
| dc | 2732 | 3.8% |
| washington | 2732 | 3.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 53384 | |
| a | 53384 | |
| o | 48421 | 10.5% |
| C | 37248 | 8.1% |
| r | 31812 | 6.9% |
| e | 24682 | 5.4% |
| n | 21600 | 4.7% |
| h | 21112 | 4.6% |
| g | 21112 | 4.6% |
| 18408 | 4.0% | |
| Other values (13) | 128787 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 367478 | |
| Uppercase Letter | 74064 | 16.1% |
| Space Separator | 18408 | 4.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| i | 53384 | |
| a | 53384 | |
| o | 48421 | |
| r | 31812 | |
| e | 24682 | |
| n | 21600 | 5.9% |
| h | 21112 | 5.7% |
| g | 21112 | 5.7% |
| c | 18380 | 5.0% |
| l | 16136 | 4.4% |
| Other values (6) | 57455 |
| Value | Count | Frequency (%) |
| C | 37248 | |
| N | 15676 | |
| Y | 11173 | 15.1% |
| J | 4503 | 6.1% |
| W | 2732 | 3.7% |
| D | 2732 | 3.7% |
| Value | Count | Frequency (%) |
| 18408 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 441542 | |
| Common | 18408 | 4.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| i | 53384 | |
| a | 53384 | |
| o | 48421 | |
| C | 37248 | 8.4% |
| r | 31812 | 7.2% |
| e | 24682 | 5.6% |
| n | 21600 | 4.9% |
| h | 21112 | 4.8% |
| g | 21112 | 4.8% |
| c | 18380 | 4.2% |
| Other values (12) | 110407 |
| Value | Count | Frequency (%) |
| 18408 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 459950 |
Most frequent character per block
| Value | Count | Frequency (%) |
| i | 53384 | |
| a | 53384 | |
| o | 48421 | 10.5% |
| C | 37248 | 8.1% |
| r | 31812 | 6.9% |
| e | 24682 | 5.4% |
| n | 21600 | 4.7% |
| h | 21112 | 4.6% |
| g | 21112 | 4.6% |
| 18408 | 4.0% | |
| Other values (13) | 128787 |
Tenure_Months
Real number (ℝ≥0)
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.12799486 |
|---|---|
| Minimum | 2 |
| Maximum | 50 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 15 |
| median | 27 |
| Q3 | 37 |
| 95-th percentile | 47 |
| Maximum | 50 |
| Range | 48 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.47828519 |
|---|---|
| Coefficient of variation (CV) | 0.5158560872 |
| Kurtosis | -1.117171643 |
| Mean | 26.12799486 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.06955528023 |
| Sum | 1382798 |
| Variance | 181.6641718 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 2043 | 3.9% |
| 25 | 1853 | 3.5% |
| 34 | 1670 | 3.2% |
| 30 | 1656 | 3.1% |
| 33 | 1648 | 3.1% |
| 21 | 1590 | 3.0% |
| 5 | 1543 | 2.9% |
| 45 | 1469 | 2.8% |
| 10 | 1448 | 2.7% |
| 28 | 1417 | 2.7% |
| Other values (39) | 36587 |
| Value | Count | Frequency (%) |
| 2 | 649 | |
| 3 | 625 | |
| 4 | 1055 | |
| 5 | 1543 | |
| 6 | 1296 |
| Value | Count | Frequency (%) |
| 50 | 737 | |
| 49 | 841 | |
| 48 | 884 | |
| 47 | 497 | |
| 46 | 756 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| 0.18 | |
|---|---|
| 0.1 | |
| 0.05 | |
| 0.12 | 122 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.597271559 |
| Min length | 3 |
Characters and Unicode
| Total characters | 190382 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.1 |
|---|---|
| 2nd row | 0.1 |
| 3rd row | 0.1 |
| 4th row | 0.1 |
| 5th row | 0.1 |
| Value | Count | Frequency (%) |
| 0.18 | 27343 | |
| 0.1 | 21314 | |
| 0.05 | 4145 | 7.8% |
| 0.12 | 122 | 0.2% |
| Value | Count | Frequency (%) |
| 0.18 | 27343 | |
| 0.1 | 21314 | |
| 0.05 | 4145 | 7.8% |
| 0.12 | 122 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 57069 | |
| . | 52924 | |
| 1 | 48779 | |
| 8 | 27343 | |
| 5 | 4145 | 2.2% |
| 2 | 122 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 137458 | |
| Other Punctuation | 52924 | 27.8% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 57069 | |
| 1 | 48779 | |
| 8 | 27343 | |
| 5 | 4145 | 3.0% |
| 2 | 122 | 0.1% |
| Value | Count | Frequency (%) |
| . | 52924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 190382 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 57069 | |
| . | 52924 | |
| 1 | 48779 | |
| 8 | 27343 | |
| 5 | 4145 | 2.2% |
| 2 | 122 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 190382 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 57069 | |
| . | 52924 | |
| 1 | 48779 | |
| 8 | 27343 | |
| 5 | 4145 | 2.2% |
| 2 | 122 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| New | |
|---|---|
| Existing |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 4.973679238 |
| Min length | 3 |
Characters and Unicode
| Total characters | 263227 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New |
|---|---|
| 2nd row | New |
| 3rd row | New |
| 4th row | New |
| 5th row | New |
| Value | Count | Frequency (%) |
| New | 32033 | |
| Existing | 20891 |
| Value | Count | Frequency (%) |
| new | 32033 | |
| existing | 20891 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 41782 | |
| N | 32033 | |
| e | 32033 | |
| w | 32033 | |
| E | 20891 | |
| x | 20891 | |
| s | 20891 | |
| t | 20891 | |
| n | 20891 | |
| g | 20891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 210303 | |
| Uppercase Letter | 52924 | 20.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| i | 41782 | |
| e | 32033 | |
| w | 32033 | |
| x | 20891 | |
| s | 20891 | |
| t | 20891 | |
| n | 20891 | |
| g | 20891 |
| Value | Count | Frequency (%) |
| N | 32033 | |
| E | 20891 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 263227 |
Most frequent character per script
| Value | Count | Frequency (%) |
| i | 41782 | |
| N | 32033 | |
| e | 32033 | |
| w | 32033 | |
| E | 20891 | |
| x | 20891 | |
| s | 20891 | |
| t | 20891 | |
| n | 20891 | |
| g | 20891 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 263227 |
Most frequent character per block
| Value | Count | Frequency (%) |
| i | 41782 | |
| N | 32033 | |
| e | 32033 | |
| w | 32033 | |
| E | 20891 | |
| x | 20891 | |
| s | 20891 | |
| t | 20891 | |
| n | 20891 | |
| g | 20891 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| 2019 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 211696 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2019 |
|---|---|
| 2nd row | 2019 |
| 3rd row | 2019 |
| 4th row | 2019 |
| 5th row | 2019 |
| Value | Count | Frequency (%) |
| 2019 | 52924 |
| Value | Count | Frequency (%) |
| 2019 | 52924 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 52924 | |
| 0 | 52924 | |
| 1 | 52924 | |
| 9 | 52924 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 211696 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 52924 | |
| 0 | 52924 | |
| 1 | 52924 | |
| 9 | 52924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 211696 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 52924 | |
| 0 | 52924 | |
| 1 | 52924 | |
| 9 | 52924 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 211696 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 52924 | |
| 0 | 52924 | |
| 1 | 52924 | |
| 9 | 52924 |
| Distinct | 52 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.07867886 |
|---|---|
| Minimum | 1 |
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 15 |
| median | 28 |
| Q3 | 39 |
| 95-th percentile | 50 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 14.53683414 |
|---|---|
| Coefficient of variation (CV) | 0.5368369047 |
| Kurtosis | -1.09793299 |
| Mean | 27.07867886 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.06662059991 |
| Sum | 1433112 |
| Variance | 211.3195469 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 31 | 1524 | 2.9% |
| 29 | 1405 | 2.7% |
| 32 | 1398 | 2.6% |
| 33 | 1344 | 2.5% |
| 35 | 1322 | 2.5% |
| 28 | 1305 | 2.5% |
| 34 | 1304 | 2.5% |
| 50 | 1258 | 2.4% |
| 49 | 1256 | 2.4% |
| 30 | 1238 | 2.3% |
| Other values (42) | 39570 |
| Value | Count | Frequency (%) |
| 1 | 1056 | |
| 2 | 829 | |
| 3 | 842 | |
| 4 | 943 | |
| 5 | 926 |
| Value | Count | Frequency (%) |
| 52 | 512 | |
| 51 | 1215 | |
| 50 | 1258 | |
| 49 | 1256 | |
| 48 | 1111 |
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.65238833 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.333363532 |
|---|---|
| Coefficient of variation (CV) | 0.5010777132 |
| Kurtosis | -1.091467617 |
| Mean | 6.65238833 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.06860865597 |
| Sum | 352071 |
| Variance | 11.11131244 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 6150 | |
| 7 | 5251 | |
| 5 | 4572 | |
| 12 | 4502 | |
| 3 | 4346 | |
| 9 | 4288 | |
| 6 | 4193 | |
| 10 | 4164 | |
| 4 | 4150 | |
| 1 | 4063 | |
| Other values (2) | 7245 |
| Value | Count | Frequency (%) |
| 1 | 4063 | |
| 2 | 3284 | |
| 3 | 4346 | |
| 4 | 4150 | |
| 5 | 4572 |
| Value | Count | Frequency (%) |
| 12 | 4502 | |
| 11 | 3961 | |
| 10 | 4164 | |
| 9 | 4288 | |
| 8 | 6150 |
| Distinct | 46 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| SALE20 | |
|---|---|
| SALE30 | |
| SALE10 | |
| ELEC10 | |
| ELEC30 | |
| Other values (41) |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.861820724 |
| Min length | 4 |
Characters and Unicode
| Total characters | 310231 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ELEC10 |
|---|---|
| 2nd row | ELEC10 |
| 3rd row | ELEC10 |
| 4th row | ELEC10 |
| 5th row | ELEC10 |
| Value | Count | Frequency (%) |
| SALE20 | 6373 | |
| SALE30 | 5915 | |
| SALE10 | 5838 | |
| ELEC10 | 4826 | |
| ELEC30 | 4647 | 8.8% |
| ELEC20 | 4540 | 8.6% |
| EXTRA10 | 2317 | 4.4% |
| OFF10 | 2250 | 4.3% |
| EXTRA20 | 2211 | 4.2% |
| OFF20 | 2202 | 4.2% |
| Other values (36) | 11805 |
| Value | Count | Frequency (%) |
| sale20 | 6373 | |
| sale30 | 5915 | |
| sale10 | 5838 | |
| elec10 | 4826 | 9.1% |
| elec30 | 4647 | 8.7% |
| elec20 | 4540 | 8.5% |
| extra10 | 2317 | 4.3% |
| off10 | 2250 | 4.2% |
| extra20 | 2211 | 4.1% |
| off20 | 2202 | 4.1% |
| Other values (37) | 12205 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 56250 | |
| 0 | 52524 | |
| L | 32139 | |
| A | 27948 | |
| S | 18126 | 5.8% |
| 2 | 17830 | 5.7% |
| 1 | 17470 | 5.6% |
| 3 | 17224 | 5.6% |
| C | 15357 | 5.0% |
| F | 13026 | 4.2% |
| Other values (20) | 42337 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 202383 | |
| Decimal Number | 105048 | |
| Lowercase Letter | 2400 | 0.8% |
| Space Separator | 400 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| E | 56250 | |
| L | 32139 | |
| A | 27948 | |
| S | 18126 | 9.0% |
| C | 15357 | 7.6% |
| F | 13026 | 6.4% |
| O | 8517 | 4.2% |
| R | 7346 | 3.6% |
| T | 6843 | 3.4% |
| X | 6575 | 3.2% |
| Other values (11) | 10256 | 5.1% |
| Value | Count | Frequency (%) |
| 0 | 52524 | |
| 2 | 17830 | 17.0% |
| 1 | 17470 | 16.6% |
| 3 | 17224 | 16.4% |
| Value | Count | Frequency (%) |
| o | 1200 | |
| u | 400 | 16.7% |
| p | 400 | 16.7% |
| n | 400 | 16.7% |
| Value | Count | Frequency (%) |
| 400 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 204783 | |
| Common | 105448 |
Most frequent character per script
| Value | Count | Frequency (%) |
| E | 56250 | |
| L | 32139 | |
| A | 27948 | |
| S | 18126 | 8.9% |
| C | 15357 | 7.5% |
| F | 13026 | 6.4% |
| O | 8517 | 4.2% |
| R | 7346 | 3.6% |
| T | 6843 | 3.3% |
| X | 6575 | 3.2% |
| Other values (15) | 12656 | 6.2% |
| Value | Count | Frequency (%) |
| 0 | 52524 | |
| 2 | 17830 | 16.9% |
| 1 | 17470 | 16.6% |
| 3 | 17224 | 16.3% |
| 400 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 310231 |
Most frequent character per block
| Value | Count | Frequency (%) |
| E | 56250 | |
| 0 | 52524 | |
| L | 32139 | |
| A | 27948 | |
| S | 18126 | 5.8% |
| 2 | 17830 | 5.7% |
| 1 | 17470 | 5.6% |
| 3 | 17224 | 5.6% |
| C | 15357 | 5.0% |
| F | 13026 | 4.2% |
| Other values (20) | 42337 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| 20.0 | |
|---|---|
| 10.0 | |
| 30.0 | |
| 0.0 | 400 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.992441992 |
| Min length | 3 |
Characters and Unicode
| Total characters | 211296 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10.0 |
|---|---|
| 2nd row | 10.0 |
| 3rd row | 10.0 |
| 4th row | 10.0 |
| 5th row | 10.0 |
| Value | Count | Frequency (%) |
| 20.0 | 17830 | |
| 10.0 | 17470 | |
| 30.0 | 17224 | |
| 0.0 | 400 | 0.8% |
| Value | Count | Frequency (%) |
| 20.0 | 17830 | |
| 10.0 | 17470 | |
| 30.0 | 17224 | |
| 0.0 | 400 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 105848 | |
| . | 52924 | |
| 2 | 17830 | 8.4% |
| 1 | 17470 | 8.3% |
| 3 | 17224 | 8.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 158372 | |
| Other Punctuation | 52924 | 25.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 105848 | |
| 2 | 17830 | 11.3% |
| 1 | 17470 | 11.0% |
| 3 | 17224 | 10.9% |
| Value | Count | Frequency (%) |
| . | 52924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 211296 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 105848 | |
| . | 52924 | |
| 2 | 17830 | 8.4% |
| 1 | 17470 | 8.3% |
| 3 | 17224 | 8.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 211296 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 105848 | |
| . | 52924 | |
| 2 | 17830 | 8.4% |
| 1 | 17470 | 8.3% |
| 3 | 17224 | 8.2% |
Marketing_Date
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| Minimum | 2019-01-01 00:00:00 |
|---|---|
| Maximum | 2019-12-31 00:00:00 |
Offline_Spend
Real number (ℝ≥0)
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2830.914141 |
|---|---|
| Minimum | 500 |
| Maximum | 5000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 2500 |
| median | 3000 |
| Q3 | 3500 |
| 95-th percentile | 4500 |
| Maximum | 5000 |
| Range | 4500 |
| Interquartile range (IQR) | 1000 |
Descriptive statistics
| Standard deviation | 936.1542467 |
|---|---|
| Coefficient of variation (CV) | 0.3306897349 |
| Kurtosis | 0.1019985876 |
| Mean | 2830.914141 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | -0.3168074538 |
| Sum | 149823300 |
| Variance | 876384.7736 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 3000 | 13529 | |
| 2500 | 10333 | |
| 3500 | 9008 | |
| 2000 | 6019 | |
| 4000 | 4882 | 9.2% |
| 1500 | 2411 | 4.6% |
| 4500 | 2115 | 4.0% |
| 1000 | 1840 | 3.5% |
| 500 | 985 | 1.9% |
| 700 | 969 | 1.8% |
| Value | Count | Frequency (%) |
| 500 | 985 | 1.9% |
| 700 | 969 | 1.8% |
| 1000 | 1840 | 3.5% |
| 1500 | 2411 | |
| 2000 | 6019 |
| Value | Count | Frequency (%) |
| 5000 | 833 | 1.6% |
| 4500 | 2115 | 4.0% |
| 4000 | 4882 | 9.2% |
| 3500 | 9008 | |
| 3000 | 13529 |
Online_Spend
Real number (ℝ≥0)
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1893.109119 |
|---|---|
| Minimum | 320.25 |
| Maximum | 4556.93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 320.25 |
|---|---|
| 5-th percentile | 682.42 |
| Q1 | 1252.63 |
| median | 1837.87 |
| Q3 | 2425.35 |
| 95-th percentile | 3396.14 |
| Maximum | 4556.93 |
| Range | 4236.68 |
| Interquartile range (IQR) | 1172.72 |
Descriptive statistics
| Standard deviation | 807.014092 |
|---|---|
| Coefficient of variation (CV) | 0.4262903199 |
| Kurtosis | -0.1476468586 |
| Mean | 1893.109119 |
| Median Absolute Deviation (MAD) | 587.1 |
| Skewness | 0.4543058812 |
| Sum | 100190907 |
| Variance | 651271.7446 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 2819.58 | 335 | 0.6% |
| 2489.36 | 311 | 0.6% |
| 1692.8 | 298 | 0.6% |
| 2155.96 | 292 | 0.6% |
| 985.28 | 291 | 0.5% |
| 2563.83 | 289 | 0.5% |
| 1292.58 | 278 | 0.5% |
| 663.46 | 274 | 0.5% |
| 1331.1 | 269 | 0.5% |
| 1172.96 | 264 | 0.5% |
| Other values (355) | 50023 |
| Value | Count | Frequency (%) |
| 320.25 | 130 | |
| 417.73 | 185 | |
| 465.4 | 43 | 0.1% |
| 478.27 | 131 | |
| 484.9 | 160 |
| Value | Count | Frequency (%) |
| 4556.93 | 141 | |
| 4349.02 | 124 | |
| 4055.3 | 189 | |
| 4019.93 | 61 | 0.1% |
| 3897.2 | 129 |
| Distinct | 9831 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 196.8032289 |
|---|---|
| Minimum | 4.12 |
| Maximum | 240587.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 4.12 |
|---|---|
| 5-th percentile | 8.8 |
| Q1 | 19.59 |
| median | 51.583 |
| Q3 | 155 |
| 95-th percentile | 427.5 |
| Maximum | 240587.5 |
| Range | 240583.38 |
| Interquartile range (IQR) | 135.41 |
Descriptive statistics
| Standard deviation | 1747.303145 |
|---|---|
| Coefficient of variation (CV) | 8.878427223 |
| Kurtosis | 7732.727063 |
| Mean | 196.8032289 |
| Median Absolute Deviation (MAD) | 40.703 |
| Skewness | 70.05685108 |
| Sum | 10415614.09 |
| Variance | 3053068.28 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 125 | 1499 | 2.8% |
| 155 | 1282 | 2.4% |
| 125.5 | 640 | 1.2% |
| 19.59 | 522 | 1.0% |
| 250 | 507 | 1.0% |
| 155.5 | 485 | 0.9% |
| 85 | 380 | 0.7% |
| 16.63 | 360 | 0.7% |
| 21.99 | 330 | 0.6% |
| 129.27 | 314 | 0.6% |
| Other values (9821) | 46605 |
| Value | Count | Frequency (%) |
| 4.12 | 1 | < 0.1% |
| 4.185 | 1 | < 0.1% |
| 4.557 | 7 | |
| 4.65 | 1 | < 0.1% |
| 4.753 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 240587.5 | 1 | |
| 115686 | 1 | |
| 109452.83 | 1 | |
| 78582.08 | 1 | |
| 65250 | 1 |
revenue_per_customer
Real number (ℝ≥0)
| Distinct | 1464 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22894.63686 |
|---|---|
| Minimum | 6.3 |
| Maximum | 306357.752 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 826.9 KiB |
Quantile statistics
| Minimum | 6.3 |
|---|---|
| 5-th percentile | 957.723 |
| Q1 | 3955.713 |
| median | 8725.835 |
| Q3 | 19589.133 |
| 95-th percentile | 113573.419 |
| Maximum | 306357.752 |
| Range | 306351.452 |
| Interquartile range (IQR) | 15633.42 |
Descriptive statistics
| Standard deviation | 41812.87602 |
|---|---|
| Coefficient of variation (CV) | 1.826317503 |
| Kurtosis | 14.84566505 |
| Mean | 22894.63686 |
| Median Absolute Deviation (MAD) | 5938.954 |
| Skewness | 3.63964285 |
| Sum | 1211675761 |
| Variance | 1748316601 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 244509.716 | 695 | 1.3% |
| 106406.408 | 587 | 1.1% |
| 118511.709 | 575 | 1.1% |
| 113573.419 | 572 | 1.1% |
| 134516.474 | 523 | 1.0% |
| 36400.311 | 366 | 0.7% |
| 53675.804 | 315 | 0.6% |
| 60381.669 | 297 | 0.6% |
| 25601.119 | 290 | 0.5% |
| 36940.336 | 261 | 0.5% |
| Other values (1454) | 48443 |
| Value | Count | Frequency (%) |
| 6.3 | 1 | |
| 7.192 | 1 | |
| 7.2 | 1 | |
| 7.74 | 1 | |
| 8.09 | 1 |
| Value | Count | Frequency (%) |
| 306357.752 | 19 | < 0.1% |
| 257792.206 | 147 | 0.3% |
| 245611.693 | 157 | 0.3% |
| 244509.716 | 695 | |
| 137971.419 | 163 | 0.3% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 826.9 KiB |
| High_value | |
|---|---|
| Low_value | |
| Medium_value |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.32807422 |
| Min length | 9 |
Characters and Unicode
| Total characters | 546603 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | High_value |
|---|---|
| 2nd row | High_value |
| 3rd row | High_value |
| 4th row | High_value |
| 5th row | High_value |
| Value | Count | Frequency (%) |
| High_value | 18009 | |
| Low_value | 17489 | |
| Medium_value | 17426 |
| Value | Count | Frequency (%) |
| high_value | 18009 | |
| low_value | 17489 | |
| medium_value | 17426 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 70350 | |
| e | 70350 | |
| _ | 52924 | |
| v | 52924 | |
| a | 52924 | |
| l | 52924 | |
| i | 35435 | 6.5% |
| H | 18009 | 3.3% |
| g | 18009 | 3.3% |
| h | 18009 | 3.3% |
| Other values (6) | 104745 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 440755 | |
| Uppercase Letter | 52924 | 9.7% |
| Connector Punctuation | 52924 | 9.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| u | 70350 | |
| e | 70350 | |
| v | 52924 | |
| a | 52924 | |
| l | 52924 | |
| i | 35435 | |
| g | 18009 | 4.1% |
| h | 18009 | 4.1% |
| o | 17489 | 4.0% |
| w | 17489 | 4.0% |
| Other values (2) | 34852 |
| Value | Count | Frequency (%) |
| H | 18009 | |
| L | 17489 | |
| M | 17426 |
| Value | Count | Frequency (%) |
| _ | 52924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 493679 | |
| Common | 52924 | 9.7% |
Most frequent character per script
| Value | Count | Frequency (%) |
| u | 70350 | |
| e | 70350 | |
| v | 52924 | |
| a | 52924 | |
| l | 52924 | |
| i | 35435 | |
| H | 18009 | 3.6% |
| g | 18009 | 3.6% |
| h | 18009 | 3.6% |
| L | 17489 | 3.5% |
| Other values (5) | 87256 |
| Value | Count | Frequency (%) |
| _ | 52924 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 546603 |
Most frequent character per block
| Value | Count | Frequency (%) |
| u | 70350 | |
| e | 70350 | |
| _ | 52924 | |
| v | 52924 | |
| a | 52924 | |
| l | 52924 | |
| i | 35435 | 6.5% |
| H | 18009 | 3.3% |
| g | 18009 | 3.3% |
| h | 18009 | 3.3% |
| Other values (6) | 104745 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| CustomerID | Transaction_ID | Transaction_Date | Product_SKU | Product_Description | Product_Category | Quantity | Avg_Price | Delivery_Charges | Coupon_Status | Gender | Location | Tenure_Months | GST | Transaction_Date_Month_x | Transaction_Date_Month_y | User_type | year_number | week_number | month_number | Coupon_Code | Discount_pct | Marketing_Date | Offline_Spend | Online_Spend | revenue | revenue_per_customer | revenue_seg | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850 | 16679 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 153.71 | 6.50 | Used | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 144.189 | 60381.669 | High_value |
| 1 | 17850 | 16680 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 153.71 | 6.50 | Used | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 144.189 | 60381.669 | High_value |
| 2 | 17850 | 16696 | 2019-01-01 | GGOENEBQ078999 | Nest Cam Outdoor Security Camera - USA | Nest-USA | 2 | 122.77 | 6.50 | Not Used | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 258.540 | 60381.669 | High_value |
| 3 | 17850 | 16699 | 2019-01-01 | GGOENEBQ079099 | Nest Protect Smoke + CO White Battery Alarm-USA | Nest-USA | 1 | 81.50 | 6.50 | Clicked | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 88.000 | 60381.669 | High_value |
| 4 | 17850 | 16700 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 153.71 | 6.50 | Clicked | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 160.210 | 60381.669 | High_value |
| 5 | 17850 | 16701 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 153.71 | 6.50 | Clicked | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 160.210 | 60381.669 | High_value |
| 6 | 17850 | 16702 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 2 | 153.71 | 6.50 | Clicked | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 320.420 | 60381.669 | High_value |
| 7 | 17850 | 16703 | 2019-01-01 | GGOENEBQ079099 | Nest Protect Smoke + CO White Battery Alarm-USA | Nest-USA | 2 | 81.50 | 6.50 | Not Used | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 176.000 | 60381.669 | High_value |
| 8 | 17850 | 16704 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 256.88 | 6.50 | Used | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 237.042 | 60381.669 | High_value |
| 9 | 17850 | 16710 | 2019-01-01 | GGOENEBJ079499 | Nest Learning Thermostat 3rd Gen-USA - Stainless Steel | Nest-USA | 1 | 153.71 | 28.78 | Clicked | M | Chicago | 12 | 0.1 | 2019-01 | 2019-01 | New | 2019 | 1 | 1 | ELEC10 | 10.0 | 2019-01-01 | 4500 | 2424.5 | 182.490 | 60381.669 | High_value |
Last rows
| CustomerID | Transaction_ID | Transaction_Date | Product_SKU | Product_Description | Product_Category | Quantity | Avg_Price | Delivery_Charges | Coupon_Status | Gender | Location | Tenure_Months | GST | Transaction_Date_Month_x | Transaction_Date_Month_y | User_type | year_number | week_number | month_number | Coupon_Code | Discount_pct | Marketing_Date | Offline_Spend | Online_Spend | revenue | revenue_per_customer | revenue_seg | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52914 | 14608 | 27753 | 2019-05-11 | GGOEWEBB082699 | Waze Mobile Phone Vent Mount | Waze | 1 | 5.59 | 6.0 | Clicked | F | California | 48 | 0.18 | 2019-05 | 2019-05 | New | 2019 | 19 | 5 | WEMP20 | 20.0 | 2019-05-11 | 3000 | 1801.66 | 11.590 | 11.590 | Low_value |
| 52915 | 14866 | 24996 | 2019-04-07 | GGOEGHPJ080110 | Google 5-Panel Cap | Headgear | 1 | 15.19 | 6.5 | Not Used | F | Chicago | 43 | 0.05 | 2019-04 | 2019-04 | New | 2019 | 14 | 4 | HGEAR10 | 10.0 | 2019-04-07 | 2500 | 2719.46 | 21.690 | 21.690 | Low_value |
| 52916 | 13029 | 32468 | 2019-07-12 | GGOEAHPA004110 | Android Wool Heather Cap Heather/Black | Headgear | 1 | 9.99 | 6.0 | Clicked | F | New York | 35 | 0.05 | 2019-07 | 2019-07 | New | 2019 | 28 | 7 | HGEAR10 | 10.0 | 2019-07-12 | 2500 | 923.40 | 15.990 | 15.990 | Low_value |
| 52917 | 12503 | 33847 | 2019-07-27 | GGOEGHPJ080310 | Google Blackout Cap | Headgear | 1 | 10.63 | 6.0 | Clicked | F | Chicago | 36 | 0.05 | 2019-07 | 2019-07 | New | 2019 | 30 | 7 | HGEAR10 | 10.0 | 2019-07-27 | 2500 | 1151.70 | 16.630 | 16.630 | Low_value |
| 52918 | 15797 | 40896 | 2019-10-17 | GGOENEBQ086499 | Nest Cam IQ - USA | Nest | 1 | 199.00 | 6.0 | Used | F | California | 27 | 0.05 | 2019-10 | 2019-10 | New | 2019 | 42 | 10 | NE10 | 10.0 | 2019-10-17 | 2500 | 1783.56 | 184.500 | 184.500 | Low_value |
| 52919 | 12990 | 46842 | 2019-12-14 | GGOENEBQ086799 | Nest Thermostat E - USA | Nest | 1 | 100.91 | 6.5 | Clicked | F | California | 47 | 0.05 | 2019-12 | 2019-12 | New | 2019 | 50 | 12 | NE30 | 30.0 | 2019-12-14 | 4000 | 3434.31 | 107.410 | 473.878 | Low_value |
| 52920 | 12990 | 46843 | 2019-12-14 | GGOENEBQ092299 | Nest Secure Alarm System Starter Pack - USA | Nest | 1 | 355.74 | 6.5 | Used | F | California | 47 | 0.05 | 2019-12 | 2019-12 | New | 2019 | 50 | 12 | NE30 | 30.0 | 2019-12-14 | 4000 | 3434.31 | 253.568 | 473.878 | Low_value |
| 52921 | 12990 | 46843 | 2019-12-14 | GGOENEBQ093499 | Nest Detect - USA | Nest | 2 | 49.95 | 6.5 | Clicked | F | California | 47 | 0.05 | 2019-12 | 2019-12 | New | 2019 | 50 | 12 | NE30 | 30.0 | 2019-12-14 | 4000 | 3434.31 | 112.900 | 473.878 | Low_value |
| 52922 | 16333 | 47144 | 2019-12-16 | GGOENEBQ092299 | Nest Secure Alarm System Starter Pack - USA | Nest | 1 | 355.74 | 6.5 | Clicked | F | New York | 41 | 0.05 | 2019-12 | 2019-12 | New | 2019 | 51 | 12 | NE30 | 30.0 | 2019-12-16 | 4000 | 3116.98 | 362.240 | 644.490 | Low_value |
| 52923 | 16333 | 47144 | 2019-12-16 | GGOENEBQ093499 | Nest Detect - USA | Nest | 5 | 49.95 | 6.5 | Not Used | F | New York | 41 | 0.05 | 2019-12 | 2019-12 | New | 2019 | 51 | 12 | NE30 | 30.0 | 2019-12-16 | 4000 | 3116.98 | 282.250 | 644.490 | Low_value |